Declare Missing Value (In Database)
(In-Database Processing)
Synopsis
Declares a missing numeric or nominal value on a selected subset.Description
The given value will be replaced with NULL throughout the specified subset, so it will be treated as a missing value by subsequent operators.
Input
example set input
Output
- example set output
Parameters
- attribute filter type The condition specifies which attributes are selected or affected by this operator.
- attribute The attribute which should be chosen.
- attributes The attribute which should be chosen.
- regular expression A regular expression for the names of the attributes which should be kept.
- use except expression If enabled, an exception to the specified regular expression might be specified. Attributes of matching this will be filtered out, although matching the first expression.
- except regular expression A regular expression for the names of the attributes which should be filtered out although matching the above regular expression.
- value type The value type of the attributes.
- use value type exception If enabled, an exception to the specified value type might be specified. Attributes of this type will be filtered out, although matching the first specified type.
- except value type Except this value type.
- block type The block type of the attributes.
- use block type exception If enabled, an exception to the specified block type might be specified.
- except block type Except this block type.
- numeric condition Parameter string for the condition, e.g. '>= 5'
- invert selection Indicates if only attributes should be accepted which would normally filtered.
- mode Select the value type of the missing value
- numeric value This parameter defines the missing numerical value
- nominal value This parameter defines the missing nominal value
- expression value This parameter defines the expression which if true equals the missing value